# XLSX Import Versions **URL:** \ **Category:** Questions\ **Tags:** scripting, integration\ **Created:** [September 26, 2023, 1:05pm UTC](https://the.fmsoup.org/t/xlsx-import-versions/3712 "2023-09-26T13:05:31Z")\ **Posts on this page:** 17\ **Page:** 1
**Author:** ![EdwinS](https://avatars.discourse-cdn.com/v4/letter/e/57b2e6/32.png) [@EdwinS](https://the.fmsoup.org/u/EdwinS)\ **Post date:** [September 26, 2023, 1:05pm UTC](https://the.fmsoup.org/t/xlsx-import-versions/3712/1 "2023-09-26T13:05:31Z")
Has anyone found what XLSX versions are supported for an FM19 import? I get a strange message, but can't find any information about supported versions. But maybe the error is simply misleading. (I can try to create the screenshot in english if it helps). Thanks! ![Bildschirmfoto 2023-09-26 um 12.29.58](https://canada1.discourse-cdn.com/flex030/uploads/fmsoup/original/2X/4/4f19061d980868a81448a12938b522475aec3122.png) ![Bildschirmfoto 2023-09-26 um 12.33.29](https://canada1.discourse-cdn.com/flex030/uploads/fmsoup/original/2X/6/668b86c4351a78de8a06a1d84fbdbf768e596c4d.png) PS: IMHO, having 2 consecutive slashes in a path is absolutely legal, but FM does not accept it. ![Bildschirmfoto 2023-09-26 um 15.04.07](https://canada1.discourse-cdn.com/flex030/uploads/fmsoup/original/2X/0/063f64317bffea09b6846a51fc7d4549b850cf93.png) ---
**Author:** ![OliverBarrett](https://avatars.discourse-cdn.com/v4/letter/o/f19dbf/32.png) [@OliverBarrett](https://the.fmsoup.org/u/OliverBarrett)\ **Post date:** [September 26, 2023, 1:52pm UTC](https://the.fmsoup.org/t/xlsx-import-versions/3712/2 "2023-09-26T13:52:22Z")
Like you said, the German states that the version isn't supported. Very odd. XLSX is the version. You shouldn't need to drill down from there. There are other ways to get Excel data into FileMaker like a no-code platform like Zapier or a high-code platform like Java (POI). ---
**Author:** ![EdwinS](https://avatars.discourse-cdn.com/v4/letter/e/57b2e6/32.png) [@EdwinS](https://the.fmsoup.org/u/EdwinS)\ **Post date:** [September 26, 2023, 1:55pm UTC](https://the.fmsoup.org/t/xlsx-import-versions/3712/3 "2023-09-26T13:55:57Z")
The test was with FM19. The same test with FM20 in English gives the same result (ignore the $$BFS...) ![Bildschirmfoto 2023-09-26 um 15.53.34](https://canada1.discourse-cdn.com/flex030/uploads/fmsoup/original/2X/d/ddc28f51068543dc763a6c6f9708aea254bb3172.png) ---
**Author:** ![OliverBarrett](https://avatars.discourse-cdn.com/v4/letter/o/f19dbf/32.png) [@OliverBarrett](https://the.fmsoup.org/u/OliverBarrett)\ **Post date:** [September 26, 2023, 1:58pm UTC](https://the.fmsoup.org/t/xlsx-import-versions/3712/4 "2023-09-26T13:58:15Z")
Yep, I understood the German (keine Übersetzung nötig). 🙂 XLSX is the current version of Excel so I'm really curious what others say. Are you creating the XLSX in Office 365 or another environment like LIbreOffice or maybe even output from some third-party software? Did you try another XLSX file? ---
**Author:** ![bdbd](https://yyz2.discourse-cdn.com/flex030/user_avatar/the.fmsoup.org/bdbd/32/620_2.png) [@bdbd](https://the.fmsoup.org/u/bdbd)\ **Post date:** [September 26, 2023, 2:29pm UTC](https://the.fmsoup.org/t/xlsx-import-versions/3712/5 "2023-09-26T14:29:29Z")
What is the file type setting in the import records script step? ---
**Author:** ![EdwinS](https://avatars.discourse-cdn.com/v4/letter/e/57b2e6/32.png) [@EdwinS](https://the.fmsoup.org/u/EdwinS)\ **Post date:** [September 26, 2023, 2:42pm UTC](https://the.fmsoup.org/t/xlsx-import-versions/3712/6 "2023-09-26T14:42:45Z")
It's Excel Workbooks ![Bildschirmfoto 2023-09-26 um 16.41.31](https://canada1.discourse-cdn.com/flex030/uploads/fmsoup/original/2X/4/4c88d337f77a42eb49846dc2356f1cc20a170184.png) ---
**Author:** ![EdwinS](https://avatars.discourse-cdn.com/v4/letter/e/57b2e6/32.png) [@EdwinS](https://the.fmsoup.org/u/EdwinS)\ **Post date:** [September 26, 2023, 2:49pm UTC](https://the.fmsoup.org/t/xlsx-import-versions/3712/7 "2023-09-26T14:49:36Z")
The output is from a 3rd party software. BTW: Importing it via File -\> Import Records works with this same file (used it to create the target table in the first place). Opened it with MS Excel, made some change and did "save as...". Same result. ---
**Author:** ![EdwinS](https://avatars.discourse-cdn.com/v4/letter/e/57b2e6/32.png) [@EdwinS](https://the.fmsoup.org/u/EdwinS)\ **Post date:** [September 26, 2023, 3:06pm UTC](https://the.fmsoup.org/t/xlsx-import-versions/3712/8 "2023-09-26T15:06:48Z")
It works with both FM19 and FM20 if I work from another computer! ---
**Author:** ![steve\_ssh](https://yyz2.discourse-cdn.com/flex030/user_avatar/the.fmsoup.org/steve_ssh/32/160_2.png) [@steve\_ssh](https://the.fmsoup.org/u/steve_ssh)\ **Post date:** [September 26, 2023, 4:23pm UTC](https://the.fmsoup.org/t/xlsx-import-versions/3712/9 "2023-09-26T16:23:42Z")
I have a colleague, who, within the last year, ran into a similar message about "wrong Excel version" when doing an import. My suspicion was always that the error message was incorrect, and that he was actually running into some sort of condition whereby FMP just wasn't able to find or access the file at the target path. I just pinged him to see if he could remind me of the resolution, but he does not recall. I mention this because some of the symptoms mentioned in this thread also suggest to me that it could be more a question about whether the file can be located/accessed during the import records script step, rather than a conflict with a file version. No guarantees, though -- this is just speculation, and not with a whole lot of substantiation. ---
**Author:** ![harvest](https://yyz2.discourse-cdn.com/flex030/user_avatar/the.fmsoup.org/harvest/32/231_2.png) [@harvest](https://the.fmsoup.org/u/harvest)\ **Post date:** [September 26, 2023, 4:31pm UTC](https://the.fmsoup.org/t/xlsx-import-versions/3712/10 "2023-09-26T16:31:53Z")
I would try to get rid of the underscore in the filename, not per se but because of the position just before the dot of the file extension... ---
**Author:** ![OliverBarrett](https://avatars.discourse-cdn.com/v4/letter/o/f19dbf/32.png) [@OliverBarrett](https://the.fmsoup.org/u/OliverBarrett)\ **Post date:** [September 26, 2023, 4:35pm UTC](https://the.fmsoup.org/t/xlsx-import-versions/3712/11 "2023-09-26T16:35:37Z")
If none of these suggestions solve the problem, I'd be inclined to take a 365-generated Excel file that you can verify "works" in this situation and compare it using a byte editor to an "identical" file generated by the third-party software. These XLSX, DOCX, PPTX files are all basically zip files, but perhaps the issue is right in the file header. ---
**Author:** ![EdwinS](https://avatars.discourse-cdn.com/v4/letter/e/57b2e6/32.png) [@EdwinS](https://the.fmsoup.org/u/EdwinS)\ **Post date:** [September 26, 2023, 5:09pm UTC](https://the.fmsoup.org/t/xlsx-import-versions/3712/12 "2023-09-26T17:09:09Z")
It works on 2 computers (Ventura 13.5.2 and Ventura 13.6), both FM19 and FM20. It doesn't work on the 3rd computer where I programmed it (Ventura 13.6), both FM19 and FM20. FileMaker versions are the same on all clients. I'll stop for the moment, maybe I'll try to compare some library directories. ---
**Author:** ![OliverBarrett](https://avatars.discourse-cdn.com/v4/letter/o/f19dbf/32.png) [@OliverBarrett](https://the.fmsoup.org/u/OliverBarrett)\ **Post date:** [September 27, 2023, 9:47am UTC](https://the.fmsoup.org/t/xlsx-import-versions/3712/13 "2023-09-27T09:47:12Z")
Please post back with updates. ---
**Author:** ![EdwinS](https://avatars.discourse-cdn.com/v4/letter/e/57b2e6/32.png) [@EdwinS](https://the.fmsoup.org/u/EdwinS)\ **Post date:** [September 27, 2023, 11:17am UTC](https://the.fmsoup.org/t/xlsx-import-versions/3712/14 "2023-09-27T11:17:53Z")
- The libraries look OK, still no idea what goes wrong on computer 3 - Changed the script to run on server as intended from the start (PSOS). For this to work, I had to copy the file via script from a "public" server directory to one of the predefined directories ([Paths in server-side scripts](https://help.claris.com/archive/fm19/en/pro-help/content/paths-in-server-side-scripts.html)). - At first, "import records" returned status 0, but imported nothing. - changing the file mode from "--wsrwsr-t" to "-rw-rw-rw-" solved this problem, too. That means, even though FMS had read rights as group, it didn't import anything, but returned OK. ---
**Author:** ![Malcolm](https://yyz2.discourse-cdn.com/flex030/user_avatar/the.fmsoup.org/malcolm/32/196_2.png) [@Malcolm](https://the.fmsoup.org/u/Malcolm)\ **Post date:** [September 27, 2023, 5:04pm UTC](https://the.fmsoup.org/t/xlsx-import-versions/3712/15 "2023-09-27T17:04:54Z")
> [@EdwinS](#): > > changing the file mode from "--wsrwsr-t" to "-rw-rw-rw-" solved this problem, too. That means, even though FMS had read rights as group, it didn't import anything, but returned OK. See what @ssh had to say about that in this thread [How to schedule an email with Excel output of records from a table records in FMS? - #9 by steve\_ssh](https://the.fmsoup.org/t/how-to-schedule-an-email-with-excel-output-of-records-from-a-table-records-in-fms/3707/9) ---
**Author:** ![TKnTexas](https://avatars.discourse-cdn.com/v4/letter/t/ad7895/32.png) [@TKnTexas](https://the.fmsoup.org/u/TKnTexas)\ **Post date:** [October 2, 2023, 11:24pm UTC](https://the.fmsoup.org/t/xlsx-import-versions/3712/16 "2023-10-02T23:24:50Z")
I have imported XLS and XLSX versions, from LibreOffice and Excel in all versions of Filemaker. They ONLY xlsx files that filed to import everytime, were the ones written by Numbers. ---
**Author:** ![OliverBarrett](https://avatars.discourse-cdn.com/v4/letter/o/f19dbf/32.png) [@OliverBarrett](https://the.fmsoup.org/u/OliverBarrett)\ **Post date:** [October 3, 2023, 12:51pm UTC](https://the.fmsoup.org/t/xlsx-import-versions/3712/17 "2023-10-03T12:51:08Z")
IMHO, Numbers is a pain. It creates HUGE ".numbers" files with no way I've ever found to configure it to create an XLSX by default. I try to avoid it.