Custom Sheet (CSV)

If you're tracking your poker data in a spreadsheet, you can easily import it into Pokerbase by creating a custom CSV file. Follow this guide to ensure your data is formatted correctly for a smooth import process. Once created

CSV Structure

Your CSV should contain the following columns:

Column Name	Description	Example
currency_code	Currency used for the session	USD
location	Where the game was played	Bellagio
stake	Blinds/Stakes of the game	5/10
table_size	Number of players at the table	9
game	Type of poker game played	No Limit Hold'em
type	Cash game or tournament	cashgame
tournament_name	Name of the tournament (if applicable)	WSOP Main Event
is_online	'x' for online games, empty for live games	x
start	Start date and time of the session	2024-10-18 14:30:00
end	End date and time of the session	2024-10-18 20:45:00
buyin_amount	Initial buy-in amount	1000
total_rebuy_amount	Total amount of rebuys	500
number_of_rebuys	Number of times rebought	1
total_addon_amount	Total amount of add-ons	200
number_of_addons	Number of add-ons	1
total_bounties_amount	Total amount won from bounties	300
number_of_bounties	Number of bounties collected	2
expenses_amount	Total expenses not from stack	50
expenses_from_stack_amount	Expenses taken from playing stack	30
cashout	Total amount cashed out	2000
total_break_minutes	Total time spent on breaks (in minutes)	45
tournament_position	Final position in tournament	3
total_tournament_entries	Total number of entries in tournament	1000
note	Any additional comments about the session	Played well, caught good cards late

Steps to Create Your CSV

Open your spreadsheet software (e.g., Excel, Google Sheets)
Create a new sheet with the column headers listed above
Enter your poker session data, ensuring each row represents a single session
Double-check that your data is in the correct format for each column
Save or export your file as a CSV

Tips for Formatting

Use consistent date format (yyyy-MM-dd HH:mm:ss) for the Date column
Be consistent with game names and locations to make filtering easier in Pokerbase
Enter monetary values as numbers without currency symbols (e.g., 500 instead of $500)

Example CSV Row

Here's an example CSV with 3 entries based on the table structure above:

currency_code,location,stake,table_size,game,type,tournament_name,is_online,start,end,buyin_amount,total_rebuy_amount,number_of_rebuys,total_addon_amount,number_of_addons,total_bounties_amount,number_of_bounties,expenses_amount,expenses_from_stack_amount,cashout,total_break_minutes,tournament_position,total_tournament_entries,note
USD,Bellagio,5/10,9,No Limit Hold'em,cashgame,,,2024-10-18 14:30:00,2024-10-18 20:45:00,1000,500,1,0,0,0,0,50,30,2000,45,,,"Played well, caught good cards late"
EUR,King's Casino,1/2,6,Pot Limit Omaha,cashgame,,x,2024-10-19 18:00:00,2024-10-20 02:30:00,500,1000,2,0,0,0,0,20,10,1800,30,,,"Tough game, managed to recover after initial losses"
USD,Rio,,,No Limit Hold'em,tournament,WSOP Main Event,,2024-10-21 12:00:00,2024-10-23 23:45:00,10000,0,0,0,0,1500,3,100,50,50000,180,3,6000,"Made a deep run, knocked out three players for bounties"

This example includes a cash game at Bellagio, an online PLO cash game, and a WSOP Main Event tournament entry, showcasing different types of poker sessions and how they can be recorded in the CSV format.

By following this structure, you'll be able to easily import your poker session data into Pokerbase, allowing for better tracking and analysis of your poker performance.