# Sync Categories Between Spreadsheets Using IMPORTRANGE() **URL:** \ **Category:** Google Sheets\ **Created:** [May 15, 2021, 11:41pm UTC](https://community.tiller.com/t/sync-categories-between-spreadsheets-using-importrange/8713 "2021-05-15T23:41:05Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![jasongoldberg3181978](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/jasongoldberg3181978/32/6673_2.png) [@jasongoldberg3181978](https://community.tiller.com/u/jasongoldberg3181978)\ **Post date:** [May 15, 2021, 11:41pm UTC](https://community.tiller.com/t/sync-categories-between-spreadsheets-using-importrange/8713/1 "2021-05-15T23:41:05Z")
I attempted to follow the directions but I need help. How can I import my categories from one spread sheet to another. I get stuck at the point where I put this formula. `=importrange(config!A1,"Transactions!A::L")` Any feedback is appreciated. ---
**Author:** ![matt](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/matt/32/303_2.png) [@matt](https://community.tiller.com/u/matt)\ **Post date:** [May 17, 2021, 6:12pm UTC](https://community.tiller.com/t/sync-categories-between-spreadsheets-using-importrange/8713/2 "2021-05-17T18:12:25Z")
Hi @jasongoldberg3181978 , I can take a shot at helping you out. What directions are you attempting to follow? If you could post the link to the directions that would help me diagnose the issue. ---
**Author:** ![randy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/randy/32/16_2.png) [@randy](https://community.tiller.com/u/randy)\ **Post date:** [May 17, 2021, 7:04pm UTC](https://community.tiller.com/t/sync-categories-between-spreadsheets-using-importrange/8713/3 "2021-05-17T19:04:55Z")
Off hand, I see two problems, @jasongoldberg3181978… First, the first argument in your `IMPORTRANGE()` should be the spreadsheet’s URL (in quotes). Check the help content. Second, you have an extra semicolon between the `A` & `L` in the second argument. Hope this helps. ---
**Author:** ![heather](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/heather/32/177_2.png) [@heather](https://community.tiller.com/u/heather)\ **Post date:** [May 17, 2021, 7:36pm UTC](https://community.tiller.com/t/sync-categories-between-spreadsheets-using-importrange/8713/4 "2021-05-17T19:36:24Z")
I’d like to ask why you want to use two separate sheets and sync categories between them 🙂 ---
**Author:** ![jasongoldberg3181978](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/jasongoldberg3181978/32/6673_2.png) [@jasongoldberg3181978](https://community.tiller.com/u/jasongoldberg3181978)\ **Post date:** [May 18, 2021, 12:51am UTC](https://community.tiller.com/t/sync-categories-between-spreadsheets-using-importrange/8713/5 "2021-05-18T00:51:14Z")
Hope all is well. I was in the tutorial section on your you tube channel. I was attempting to implement this monthly budget sheet. I noticed that it was incomparable. I was trying import my categories to the foundation template so I could use the monthly budget with the categories I made. I’m probably making no sense. I’m a newbie and I’m am just learning. Do y’all have phone or video support ! Any feedback is appreciated. ---
**Author:** ![heather](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/heather/32/177_2.png) [@heather](https://community.tiller.com/u/heather)\ **Post date:** [May 18, 2021, 2:23pm UTC](https://community.tiller.com/t/sync-categories-between-spreadsheets-using-importrange/8713/6 "2021-05-18T14:23:16Z")
Hi @jasongoldberg3181978, You can just copy & paste the categories from one sheet to another. No need to use this IMPORTRANGE step. It’s overcomplicating what you’re trying to achieve here. If you’ve already categorized a bunch of data in the original sheet you can either copy & paste it too from the original sheet to the new sheet or you can try the Labs add-on Migration Helper to get that customized data over into the new sheet (the Categories sheet data too for that matter!) > [@Docs: Migration Helper](https://community.tiller.com/t/how-to-use-the-migration-helper-from-tiller-labs/802): > > Overview The Migration Helper is built to help users migrate enriched personal-finance data— e.g. categories, splits, manual balances, etc.— from an old “source” Tiller Money spreadsheet to a new “destination” Tiller Money spreadsheet. If you are considering migrating, review the [recommended workflow](https://community.tiller.com/t/how-to-use-the-migration-helper-from-tiller-labs/802#how-to-use-the-migration-helper). The Migration Helper is a best-effort community built workflow for a very complex migration problem. We hope this tool helps you, but please be aware that this workflow will not work for every… We don’t have phone support, but you can always write to us using the messenger in the lower right corner of the Console at [https://sheets.tillerhq.com/auth/google](https://sheets.tillerhq.com/auth/google) for issues about the Foundation template or bank data feeds. We also offer a live weekly webinar that you can attend and ask questions live via the Q&A chat tool or watch a recording of a prior session. > [@Tiller Foundations Webinar](https://community.tiller.com/t/free-weekly-webinar-tiller-money-foundations/2658): > > Details & Replay The Foundations Webinar usually runs for 6 weeks at the start of each year and covers how to get started with Tiller and use it for budgeting and cash flow tracking. Each session on the dates below covers the same basic getting started steps with variations in the questions that are asked during the Q&A. Most recent webinar recording [Click here to access the recording from Feb 18, 2025 @ 12PM PST / 3PM EST](https://us02web.zoom.us/rec/share/yhGwO_C9f1vBcd-Two589iWabZj5ytq-byjW4_yuGAh8sdTEcQptQhaLHGPNNv5L.V4O6v36Q-O56tSdL)Upcoming webinars We don’t currently have any webinars scheduled, che…