I keep trying to import a .csv file that I created in Tap Forms on another computer and it simply won’t import all of the fields (sporadic as to which ones it does or doesn’t). Since Tap forms can’t support many users syncing to iCloud working with the same database, I was going to have each user export a .csv then import each one of them but I’m unable to do that since it doesn’t function properly. Does anyone else have this issue and or a solution, possibly a work around?
Hi,
use settings as shown on picture. Importing in both excel as numbers gives no problems.
Leo
Attachments:
You must be
logged in to view attached files.
Hi Anthony,
The File Encoding setting may be tripping you up a bit. You need to make sure that you use the correct File Encoding setting. For Mac Excel it’s generally best to use Mac OS Roman. For Windows Excel, use Windows Latin 1. Or you may need to use UTF-8 if you’re getting your CSV file from some other app.
Thanks!
Brendan
Leo,
I tried this using the same settings you showed in the picture and it jumbled the fields completely in excel. I appreciate your help though. I’m hoping I can get this to work because it’s a pretty handy program.
I”m using Mac Excel and encoding it Mac OS Roman, it just doesn’t maintain the integrity of the data either in Tap forms or Excel. I’m using tracking numbers in the data base and need them to remain in tact with each record, if that can’t work the whole thing is pointless. I’ve had a pretty easy time exporting for example my quickbooks data to excel as a csv so I know this is doable, for some reason this just isn’t keeping fields in any way organized. Some is in rows, some columns, field names are mostly in one column but not all, that kind of thing.
Hi Anthony,
I’m sorry but I misunderstood your original message. I thought you were importing into Tap Forms from Excel. But it sounds like you’re going the other way around, exporting from Tap Forms and importing into Excel.
Can you email me a sample CSV file from Tap Forms that you’re having troubles importing into Excel?
I do plan on adding an Excel export option to Tap Forms Mac so it can generate Excel files directly without having to go through CSV.
Thanks,
Brendan
.
