Importing Data into Poler

Find out how you can import your data from other sources into Poler

You may have existing poker session data that was created elsewhere that you want to import into Poler, so that your records are complete.

Maybe you previously used a different app, or kept records in a spreadsheet, or even some kind of notes system.

Luckily, there are a couple of options available to you to get your data imported into Poler.

Firstly, you can import your data using the standard Poler CSV importer. By formatting your session data in the Poler CSV format, you can import any data you like, regardless of the source. More on the Poler CSV format below.

Alternatively, if you are importing data from the Poker Bankroll Tracker app, then things are even easier. Poler supports importing Poker Bankroll Tracker Session CSVs directly, so all you have to do is select the CSV file for import, and you’re good to go.

Importing from Poker Bankroll Tracker

Importing a Poker Bankroll Tracker CSV couldn't be easier.

Firstly, save the file that you want to import somewhere in the Files app on your iPhone (e.g. in the Documents folder in iCloud Drive, or ‘On My iPhone’).

Then, go to Poler > Settings > Import Data > Poker Bankroll Tracker, tap on Select File, and find your file.

Tap Import to complete the process. That’s it! You’re done. You will now see your imported sessions in the app

All of the sessions that are imported will automatically have a ‘PBT Import’ tag added to them. This allows you to easily find those sessions, report on them separately, and to verify that everything is correct.

Importing in the Poler CSV Format

By formatting your data as a Poler CSV, you can import any of your existing poker session data into Poler.

Once you have formatted your data in the format outlined below, you need to save it somewhere in the Files app on your iPhone (e.g. in the Documents folder in iCloud Drive, or ‘On My iPhone’).

Then, go to Poler > Settings > Import Data > Import Poler Data, tap on Select File, and find your file.

Tap Import to import the file, and that’s it.

The Poler CSV Format

In order to import session data into Poler, format your Sessions as a CSV in the format outlined below.

Spreadsheet apps such as Numbers and Excel can be used to easily create CSV files.

Poler CSV format

1 - Cash/Tourney Identifier:

A string that denotes the session type. Either ‘Cash' or ‘Tourney'.

2 - ID:

A unique identifier for the session. It doesn’t matter what it is, exactly – it just has to be unique. E.g. incrementing integers (1, 2, 3, ...).

3 - Session Start Date/Time:

The start date/time for the session. Must be in the format yyyy-mm-dd HH:MM, with a 24-hour clock. For example, 2024-12-01 17:12.

4 - Session End Date/Time:

The end date/time for the session. Must be in the format yyyy-mm-dd HH:MM, with a 24-hour clock. For example, 2024-12-01 16:12.

5 - Location:

The name of the location for the session. If a location with the same name (and location type and setting) already exists in your database, it will be used. If a matching location does not already exist, a new one will be created. For online sessions, this would be the name of the poker site.

6 - Location Type:

The type of location, for example ‘Casino' or ‘Online Poker Room'. If a location type with the same name (and setting) already exists in your database, it will be used. If a matching location type does not already exist, a new one will be created.

7 - Setting:

Setting refers to whether the location is a live setting or online. This should be a string that is either ‘Live' or ‘Online'.

8 - Game Type:

The type of game played during this session, e.g. ‘No Limit Holdem’, ‘Pot Limit Omaha’, ‘7 Card Stud’, etc.

This could be any name that you want to refer to the game as, e.g. ‘NLH’ or ‘No Limit Holdem’ are both valid, but you should be consistent and make sure that you use the same name for the same game throughout the data to avoid duplicates.

Many common games have already been added to your Poler database, so, if you want to avoid duplicates, you can check for the name that has already been used for each game type in Settings > Game Types.

9 - Buy-In:

Your initial buy-in for the session. This should be a numeral, without any thousands separators or currency symbols, e.g. ‘5000' for a $5,000 buy-in.

10 - Re-buys:

Your total re-buys for the session (i.e. do not include the initial buy-in, as this has already been included above). This should be a numeral, without any thousands separators or currency symbols, e.g. ‘10000' for a $10,000 buy-in.

11 - Cashout:

Your total cashout amount for the session. This should be a numeral, without any thousands separators or currency symbols, e.g. ‘25000' for a cashout of $25,000.

12 - Note:

Any notes you might have for the session. As this is a CSV file, this cannot include any commas.

13 - Tourney Type:

The type of tournament being played, for example ‘MTT' for multi-table tournaments, or ‘SNG' for sit and goes. You can use any name for the type of tournament that you like here, but again, be consistent. Check existing values in Settings > Tourney Types.

For tournament sessions only. Leave blank for cash games.

14 - Bankroll:

The name of the bankroll used for this session. Check for existing bankrolls in Settings > Manage Bankrolls. The default bankroll in Poler is called ‘Main Bankroll'.

15 - Blank:

Leave this field blank.

16 - Small Blind:

The small blind for the session. This should be a numeral, without any thousands separators or currency symbols, e.g. ‘5' for a small blind of $5.

For cash games only. Leave blank for tournaments.

17 - Big Blind:

The big blind for the session. This should be a numeral, without any thousands separators or currency symbols, e.g. ‘10' for a big blind of $10.

For cash games only. Leave blank for tournaments.

18 - Ante:

The ante for the session. This should be a numeral, without any thousands separators or currency symbols, e.g. ‘5' for a small blind of $5. Leave blank if there was no ante.

For cash games only. Leave blank for tournaments.

19 - Bring-in:

The bring-in for the session. This should be a numeral, without any thousands separators or currency symbols, e.g. ‘5' for a bring-in of $5. Leave blank if there was no bring-in.

For cash games only. Leave blank for tournaments.

20 - Number of Entrants:

The number of entrants in a tournament. This should be a numeral, without any thousands separators, e.g. ‘1000' for 1,000 entrants.

For tournament sessions only. Leave blank for cash games.

21 - Places Paid:

The number of places paid in a tournament. This should be a numeral, without any thousands separators, e.g. ‘200' for 200 places.

For tournament sessions only. Leave blank for cash games.

22 - Place Finished:

Your finishing position in a tournament. This should be a numeral, without any thousands separators, e.g. ‘1' for first place 🏆.

For tournament sessions only. Leave blank for cash games.

Undoing an Import

If you decide that you want to undo an import that you have done, don’t worry! You can easily do so.

Poler automatically makes a backup of your database before performing every import. That way, if you later decide that you want to undo the import for any reason – maybe you imported the wrong file, or you realise that you should have made some amendments to the data before importing – you can restore the pre-import snapshot to go back to exactly the same state that you were in before the import.

You can find and restore your backups in Poler > Settings > Restore Backup.

Fin

If you still need help after reading the information on this page, or if you want to request that we add support in Poler for importing data from another app or in another specific format, get in touch here.